﻿CREATE VIEW [dbo].[ASMS_V_BookingService]
	AS
SELECT BS.*,
	SC.Code as ServiceCategoryCode,
	SC.Name as ServiceCategoryName
FROM [ASMS_BookingService] as BS
	left join ASMS_ServiceCategory as SC on SC.Id = BS.ServiceCategoryId
